use vudu
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[ConsultarEscuelaRol]
AS
BEGIN
	SET NOCOUNT ON;

    SELECT e.id_Escuela, e.nombre
	FROM Escuela e
	WHERE e.id_Escuela NOT IN (SELECT r.fk_id_escuela FROM ROL r WHERE fk_id_escuela is not null);
END